update Portals 
set URLAuthority = 'localhost:4342' 
where Name='sandbox'

select * from portals